FO_ClientUserLoc

This table is cross references of client codes to one or more user location codes. The system uses the table to execute a rule that allows the validation of a client code and patient location. A client code is assigned to a Client User Location Group Code. This code is assigned by the administrator to group one or more clients for this functionality. The system then uses the entries in this table to decide if a particular group code and user location is valid.

Each record in this table is a group code user location decision point. If this rule is activated and a group code is assigned to a client then the system will search this table to find if a user location specific rule is defined. The rule will allow the system to present the user with a message and clear the patient location so the user will be forced to re-enter it. The execution point of this rule is when the Exit button in the order screen is clicked.

 

Field Type Notes

ClientUserLoc_ID

int

ID field, a counter. Unique

ClientUserLocGroup

varchar(50)

Location group code.

Enter a valid location group code as in the FO_Clients table.

UserLocation

varchar(50)

Enter a valid user location code.

UserMessage

varchar(255)

Message to display which describes this action.

Enter the message to display.

BlankPtLocation

varchar(1)

Determines if the user patient location field is cleared meaning that the patient location code must be entered.

Enter Y or skip this entry.

Y = clear the user patient location field

Skip this entry or leave blank = do not clear the field

EditDate

datetime

Date record was last edited.

Informational